| Pages: [1] |
1. Blueprint Material List - in EVE Technology Lab [original thread]
Was using sql server for the SQL queries, so when it failed I grabbed the data from sql and put into access. Thanks for the info though, will take a look for Access.
- by Big FatWallet - at 2012.10.16 15:09:00
|
2. Blueprint Material List - in EVE Technology Lab [original thread]
Thanks Steve. I think it didn't recognise 'greatest' but can't be certain. Will try and write some queries tonight to try and grab the data.
- by Big FatWallet - at 2012.10.16 12:29:00
|
3. Blueprint Material List - in EVE Technology Lab [original thread]
Perfect thanks guys. I checked out the ramTypeRequirements last night and realised that anything with a damageperjob of 0 was a skill so didn't include it? At the moment pulling the data into access and using that for queries as my sql isn't the...
- by Big FatWallet - at 2012.10.16 09:55:00
|
4. Blueprint Material List - in EVE Technology Lab [original thread]
Hi guys, I have been banging my head trying to get a blueprint material list from the datadump. Can anyone help me with this please? So far I have extracted invTypeMaterials, invTypes, invBlueprintTypes and cross refering them in access. I'm sti...
- by Big FatWallet - at 2012.10.15 07:22:00
|
5. Asset List & Station Containers - in EVE Technology Lab [original thread]
Evening folks, Can anyone tell me whether station containers are listed in the Asset List api (https://api.eveonline.com/char/AssetList.xml.aspx) Many thanks in advance.
- by Big FatWallet - at 2012.08.29 19:53:00
|
6. Asset API into mysql (using php?) - in EVE Technology Lab [original thread]
Managed to fix it. Thanks for your help guys. I was close.... mysql_query("INSERT into player_inventory (player_name, item_id, qty) Values ($user, $row['typeID'], $row['quantity'])") or die(mysql_error()); had to change the array variables to...
- by Big FatWallet - at 2012.08.28 22:23:00
|
7. Asset API into mysql (using php?) - in EVE Technology Lab [original thread]
No errors but the table does not populate. Is there an easier way to take the asset list and insert the typeID and quantity (along with a user from a cookie) into a mysql database?
- by Big FatWallet - at 2012.08.28 21:19:00
|
8. Asset API into mysql (using php?) - in EVE Technology Lab [original thread]
Changed and I now get the following error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/bigfatw/public_html/td/charimport.php on line 20
- by Big FatWallet - at 2012.08.28 21:11:00
|
9. Asset API into mysql (using php?) - in EVE Technology Lab [original thread]
I've never written a single line of python sorry :( I did have a characterID variable on the end of the URL but removed it by accident when pasting into here. I get the following error: Parse error: syntax error, unexpected T_VARIABLE in /home/...
- by Big FatWallet - at 2012.08.28 20:37:00
|
10. Asset API into mysql (using php?) - in EVE Technology Lab [original thread]
Hi guys, Noob coder and pulling my hair out so appreciate any help. I'm trying to import my asset api into a mysql database using php. I've done a bit of research and tried some code but to no avail. [code] $url="https://api.eveonline.com/c...
- by Big FatWallet - at 2012.08.28 18:51:00
|
11. Static Dump out of date? - in EVE Technology Lab [original thread]
Many thanks, I hadn't realised I needed to factor in the waste. Thanks.
- by Big FatWallet - at 2012.08.28 05:32:00
|
12. Static Dump out of date? - in EVE Technology Lab [original thread]
Hi guys, might be a stupid question. Is the static dump out of date? I downloaded Inferno_1.2_76477_db which contained DATADUMP201208080939.bak select eve.dbo.invTypeMaterials.typeID, eve.dbo.invTypeMaterials.materialTypeID, eve.dbo.invTypes....
- by Big FatWallet - at 2012.08.27 21:59:00
|
| Pages: [1] |
| First page | Previous page | Next page | Last page |